Creates a relational index on a specified table or view , or an xml index on a specified table 為指定表或視圖創(chuàng)建關系索引,或為指定表創(chuàng)建xml索引。
When all is specified , relational indexes , both clustered and nonclustered , and xml indexes on the table are reorganized 如果指定all ,將重新組織表中的關系索引(包括聚集索引和非聚集索引)和xml索引。
Db2 uses the relational indexes to filter qualifying rows to a small number , and then applies any additional xml query predicates to these interim results before returning the final result set Db2使用關系索引將符合條件的行過濾到一個較小的量,然后在返回最終結果之前,將更多的xml查詢謂詞應用到這些臨時的結果上。
Although we have not created any relational indexes , we will create some xml indexes to explain how db2 native xml support allows us to create an index from any element or attribute in the document 雖然我們沒有創(chuàng)建任何關系索引,但將創(chuàng)建一些xml索引來說明如何使用db2原生xml支持從文檔中的任何元素或屬性創(chuàng)建索引。